UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jPmvLc1y9SUQ38grQlyMK6xllWt2XBnOlp4Xe6Z0SJ4='
WHERE
key_id = '5d6c6256a2d5e27e98d5a27da7ec577a6249107245a8d357f4b959a626314aa7'
AND (
token = 'jPmvLc1y9SUQ38grQlyMK6xllWt2XBnOlp4Xe6Z0SJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)