UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UfZmL6csy0CtCcIdXr0Xh3FXOoC1zU/MkPaZA7YvVeA=' 
WHERE 
  key_id = 'b84e7de4ae32c0371c5931e0cd3cbfae7c0496f5773d7c216d4c2c8658b21e4c' 
  AND (
    token = 'UfZmL6csy0CtCcIdXr0Xh3FXOoC1zU/MkPaZA7YvVeA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046