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