UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QEPSbogmPO04iSFwcgYXUhHuRT7SCzPt40k07yCjuFE=' 
WHERE 
  key_id = '6fcb8fa1103ee1963b5f42b902d6ea461ccbfdd4faa2e640f513019c52678f09' 
  AND (
    token = 'QEPSbogmPO04iSFwcgYXUhHuRT7SCzPt40k07yCjuFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028