UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AVoFE3zyAjjNjy6DJPcW0R/5z3JKKdmpBroDzb6Jc3U=' 
WHERE 
  key_id = '8e6317f1d4a51e1ca5f4bd3aa8f385c31d3ce61f9bb4981788d1f0a37b7eaae6' 
  AND (
    token = 'AVoFE3zyAjjNjy6DJPcW0R/5z3JKKdmpBroDzb6Jc3U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034