UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JsUcjjsXBghAqJaVqiE5R0eJQqPI5Q/O2meVfJiXswU='
WHERE
key_id = 'fc9e818b8e635541f4f27b7ea5197728f62ac5cfe7491508b37fd41331d8fdc4'
AND (
token = 'JsUcjjsXBghAqJaVqiE5R0eJQqPI5Q/O2meVfJiXswU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)