UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'D20uechujbz6sFEp9058mXOGmXZTeFBpOR9QrbjWpJA=' 
WHERE 
  key_id = '1f5f6b8d09950e17f749c9110e159c97d6f3ef3e7f5bb8d4862e1e3413f7cc37' 
  AND (
    token = 'D20uechujbz6sFEp9058mXOGmXZTeFBpOR9QrbjWpJA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034