UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'izWl/F/fi7/8CIqAM/73o+tUXoINpBRqP3/RyRgt9dU=' 
WHERE 
  key_id = '13927a74cc5a68e44cd07f898be9b7b192b2e70ed642e36f6d2d0f2f1bd1486b' 
  AND (
    token = 'izWl/F/fi7/8CIqAM/73o+tUXoINpBRqP3/RyRgt9dU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030