UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pQzxIdgQib2bMFWogQDMhm5eKf13/uTFJyasY6/9ZSU=' 
WHERE 
  key_id = '95735eaf68cd14e1f0b652d3419a8607f3e5aeaff7c22e0245c648ef6b742d6d' 
  AND (
    token = 'pQzxIdgQib2bMFWogQDMhm5eKf13/uTFJyasY6/9ZSU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029