UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6DogF2jLSwlIU5QhodIaoUv7zqDWgY8kEsx9I9+GlHk='
WHERE
key_id = '7bc41e3d778226632f66815f350f6998891cef3cb1d3d2e1a9b8dbcd9fe6e122'
AND (
token = '6DogF2jLSwlIU5QhodIaoUv7zqDWgY8kEsx9I9+GlHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)