UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9v7yp3POZ9w6zmwZKxB87AtbG6gwvWoVHg6MpiIhDg='
WHERE
key_id = '07f4bd9cf8ad5c232e97be2f305cc5e87fe9a07cb63df265972b1cbd9a1de4ce'
AND (
token = 'd9v7yp3POZ9w6zmwZKxB87AtbG6gwvWoVHg6MpiIhDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)