UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5EGurQhpurKbhD68UXxfcK18no1PZVF3jn/VD1u4c3o=' 
WHERE 
  key_id = '06e996196c348d44a2b4626f6d71f2701c29407e2d7419c4d2a81476ac34a017' 
  AND (
    token = '5EGurQhpurKbhD68UXxfcK18no1PZVF3jn/VD1u4c3o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034