UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrwUPLbfL0R7qzjAr2AVUBED7RKYvf79rWcTrp7lNns='
WHERE
key_id = 'd7fae1d74e12def51ec9d96232ee13290bd125955b5048a9a18c74738872019c'
AND (
token = 'XrwUPLbfL0R7qzjAr2AVUBED7RKYvf79rWcTrp7lNns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)