UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mezn+OzIjWbskt2p+cf+FrNHHn+iEE/3ftuROU6dUnM=' 
WHERE 
  key_id = '2738cf9a0f36e26158656766e3ab0a9cd807ac2f8327091d73a39b61307608f9' 
  AND (
    token = 'mezn+OzIjWbskt2p+cf+FrNHHn+iEE/3ftuROU6dUnM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044