UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2FLFtoMj4llz1Zml7ond8ge9E0eC7CSUjPnf6199vbY=' 
WHERE 
  key_id = '46b965c803fe1fbfe1a1ff1dd2c0b82fe5ec120a2ceaa54174c4df9dd22aa7fc' 
  AND (
    token = '2FLFtoMj4llz1Zml7ond8ge9E0eC7CSUjPnf6199vbY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021