UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQjtWnM/2tAIbv3wWoHE2QtqScIjSLVGJom5qtZCBY8='
WHERE
key_id = '496091fb1d34b8b84ee550d6125782a7942fcdd7ebca0cdf90e8e592e3011a1d'
AND (
token = 'ZQjtWnM/2tAIbv3wWoHE2QtqScIjSLVGJom5qtZCBY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)