UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2VIe8td50JfCyTBEctXp8yGLz1NKCSFVGkC02jCE36o=' 
WHERE 
  key_id = 'd33956ff69f68ad3640c0ef397094e11f214484eb04949175ee18ad6c31003a2' 
  AND (
    token = '2VIe8td50JfCyTBEctXp8yGLz1NKCSFVGkC02jCE36o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032