UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PCo1YKZ1PKtcIAh+6LX97ZynyB+qWl/Swk9J2xYRpFk='
WHERE
key_id = 'aa787442594ce296e9f9ae15f236a5554c73320e8b3a2d6dc2a71db321ec02cc'
AND (
token = 'PCo1YKZ1PKtcIAh+6LX97ZynyB+qWl/Swk9J2xYRpFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)