UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NYS67MzI5fgzzSI/jDdaM6/YgwUP+B7ZB8wn+ffij4='
WHERE
key_id = 'f964b80c5c58d55bc42ccaa7b3e27ea3f2d7dbada812662218aac47e9c4232ee'
AND (
token = '2NYS67MzI5fgzzSI/jDdaM6/YgwUP+B7ZB8wn+ffij4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)