UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvfTECFr4f0XJDPfkEv7vidfwzDRzvUdNl0+eWCkYuE='
WHERE
key_id = 'b148e6dc7c69ba088337f1bcad8bb4fcb67452c231c5a8b38b7d78fcd7204fce'
AND (
token = 'KvfTECFr4f0XJDPfkEv7vidfwzDRzvUdNl0+eWCkYuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)