UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fag2Yv9DKmLgsClJkLflgcg3S7RhHJHk+a8F4AJL3+A='
WHERE
key_id = 'a20e3f3964296c4fe22e717cec3588a535fa342c486a10ae1b4d13272ab4f77f'
AND (
token = 'fag2Yv9DKmLgsClJkLflgcg3S7RhHJHk+a8F4AJL3+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)