UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GBcWcCTluwV0hF2PjOC+TZQd8B+/ykY2bW88qNWSzc='
WHERE
key_id = 'c00fcf4751b70b8a79175cd2b294b96724f8c472e3485b49afa9917efda32cb1'
AND (
token = '3GBcWcCTluwV0hF2PjOC+TZQd8B+/ykY2bW88qNWSzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)