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