UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4tIoVjKMkILFHr8VOZx5pmdxseapfxklf1UmxH8nWW0='
WHERE
key_id = '6524dc7e70e8b92501810300037adedb9b47de5df8c7763f97b035ae1512e74e'
AND (
token = '4tIoVjKMkILFHr8VOZx5pmdxseapfxklf1UmxH8nWW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)