UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AgQj417gAFKQJJBdBRMkig7KS/Af8MjUnlhZzjUepuo=' 
WHERE 
  key_id = 'cf3b6b3f5ba8bebda8cb44712e8f31ccad5c46ac27b366cc8a1a0b785da56590' 
  AND (
    token = 'AgQj417gAFKQJJBdBRMkig7KS/Af8MjUnlhZzjUepuo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025