UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Qq2TtYiB4w9Fv1OOQo5CUtrDMPfKcSAcbsGxg6uLvzQ=' 
WHERE 
  key_id = '8f2e5bcd97476ee61807384ad04ab682fe5eb78ca8d9b2dc88a0e5155e8c65af' 
  AND (
    token = 'Qq2TtYiB4w9Fv1OOQo5CUtrDMPfKcSAcbsGxg6uLvzQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036