UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'V01+J0WZsqfzHy/LJ94xlH66a+oXt5jW8ZhjDzI8RHA=' 
WHERE 
  key_id = '4139743833dd800524751bd0e8ac4bc2681359d3dff97e167908aca8d8ad3141' 
  AND (
    token = 'V01+J0WZsqfzHy/LJ94xlH66a+oXt5jW8ZhjDzI8RHA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033