UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RuY+Kv6QHAlyXACidIJufAy+5mfuC0771OJe0Th+KmM='
WHERE
key_id = '242bc7c1362f0e05f6e9895dea5adce768e8f21cfa3a6b7e5e727f83128a9ad2'
AND (
token = 'RuY+Kv6QHAlyXACidIJufAy+5mfuC0771OJe0Th+KmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)