UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'exvop69MDFkrjzVU9BYIFxnvAmBg3OqtivX4n3g6w4o='
WHERE
key_id = 'a2f3e8bfc77e167c48b03e83594333cb8b2ced439c411f4e44625b8caeb68f43'
AND (
token = 'exvop69MDFkrjzVU9BYIFxnvAmBg3OqtivX4n3g6w4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)