UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bis39K7xV6t+kM8Yk/6ef+gTHcHavgBO+aISIw0pQjw=' 
WHERE 
  key_id = '2c65cce083bb4403bebff8b0c56dc53c4d4f41610454ca48d646c96a52177dc5' 
  AND (
    token = 'bis39K7xV6t+kM8Yk/6ef+gTHcHavgBO+aISIw0pQjw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021