UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uA1Cd+Pm5+5ZMM9pMV4a6hDKlDavdIlku8wL90cB+0o=' 
WHERE 
  key_id = 'def45c8f9f6cb3b1544ea7f68889ebbf888a27f1b49870b81be2bcf2a80ca46e' 
  AND (
    token = 'uA1Cd+Pm5+5ZMM9pMV4a6hDKlDavdIlku8wL90cB+0o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030