UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q9DSIpG8DZZXt5rrCHPv8WLFvBfJNxcAf1JF3Ru51QU=' 
WHERE 
  key_id = '7da4fc3632c3988855644c5102fa4ed1b799ff7c107e49600b0b1363df83bcaf' 
  AND (
    token = 'Q9DSIpG8DZZXt5rrCHPv8WLFvBfJNxcAf1JF3Ru51QU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037