UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ORvRVulscegLEw0yXqYgVvpQCUF4yFCAh8WiEwKDqY='
WHERE
key_id = '0cfd2ae9a3cf915a95cd5d84fee7230d95eccc5282d1ceee8b7d6d9784637be2'
AND (
token = '6ORvRVulscegLEw0yXqYgVvpQCUF4yFCAh8WiEwKDqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)