UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+KnMmjMx48oxfo69WgGsknb/jaVXKOgWG2zfB/WDlCU=' 
WHERE 
  key_id = '76d89428e17fc1d1bc9463207a90140d5b4cd4ecd1ebaf802abdb2ac5c0c573a' 
  AND (
    token = '+KnMmjMx48oxfo69WgGsknb/jaVXKOgWG2zfB/WDlCU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047