UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMNKmNL1xVVCi3zPcaY9SqgPrF5aRV0DQUwpoxStiz4='
WHERE
key_id = '7b44647c4500b9ab73cf3e1f2abec2b5ed4ddb920d5e7071155ba2cbcac22169'
AND (
token = 'ZMNKmNL1xVVCi3zPcaY9SqgPrF5aRV0DQUwpoxStiz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)