UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xBL0kOefyCO9J5cDzCXkUKj3xWeGfgrJrTdws0Zvxw='
WHERE
key_id = '1fb4021a554d3788223a8b5c4ea490ded90a400c666d0fc3f4b7a532e076d9b7'
AND (
token = '6xBL0kOefyCO9J5cDzCXkUKj3xWeGfgrJrTdws0Zvxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)