UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GC3uuxvnxNbM/0ZvMz65VG+I97CsOgc4LLC7EtN8+qc=' 
WHERE 
  key_id = '2db394f3e9c2854de269e6601a1911f08f468acf059656300410fdd87b3acaf8' 
  AND (
    token = 'GC3uuxvnxNbM/0ZvMz65VG+I97CsOgc4LLC7EtN8+qc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029