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