UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nnzZ3ZynEombgRxZcTQe5NQd45hmz0ihd4zztcrrds='
WHERE
key_id = '46e12834047ffac9605d303ad6095ef092edb8d8b347f9e18395a703db26a2bc'
AND (
token = '9nnzZ3ZynEombgRxZcTQe5NQd45hmz0ihd4zztcrrds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)