UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5pZ96ViEa5wjU7oYLBrH1Ma7CWyuRVq4dD8u7B0r/qg=' 
WHERE 
  key_id = '9f2104d64130df4f284135c6c268f8f6364c69e1ec7d27e2e461c87959d2197d' 
  AND (
    token = '5pZ96ViEa5wjU7oYLBrH1Ma7CWyuRVq4dD8u7B0r/qg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017