UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mn9o1mZPLsRioD03+dylzJYmwEbwPsf2FufnQRDHME8='
WHERE
key_id = '2047d6ffb54cb7d8b84be7e64db7745b06fee5b3a410a230c4843e8ee1c9f19a'
AND (
token = 'mn9o1mZPLsRioD03+dylzJYmwEbwPsf2FufnQRDHME8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)