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

Query time 0.00030