UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+PJNYcxoI5L0Dfc2QiWM00l2/Vw0BeGocjzGQ0OByP0=' 
WHERE 
  key_id = '9a22168bbd6de3a27aae64c9ad171f3c68656ae175f019589281285f47018d27' 
  AND (
    token = '+PJNYcxoI5L0Dfc2QiWM00l2/Vw0BeGocjzGQ0OByP0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042