UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QMkmHr1HNKVCHEHXl4iSLEF05FfM4w64Pp28P3PrJ7w='
WHERE
key_id = '6bca0e85db1ffe1a1997be14293cf335b90408cd14579551d6b58231e863736b'
AND (
token = 'QMkmHr1HNKVCHEHXl4iSLEF05FfM4w64Pp28P3PrJ7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)