UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g8r6ygYx8Sdzd3Hj0Wml9GjYjEwVwQFXVuP4tqE7NF0=' 
WHERE 
  key_id = '9aa62c8014b0a2e54b1c72bd3f987b488917e67eee85182389892bba79127d55' 
  AND (
    token = 'g8r6ygYx8Sdzd3Hj0Wml9GjYjEwVwQFXVuP4tqE7NF0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047