UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Jb60flMN4sNhvfkCFeU5qAGGmGLUFf3YZHyEzxzTDEU=' 
WHERE 
  key_id = '659b2929b772a0a23c363e4b063ecdb07f05ba24e5f16293b2f2f90ed735b270' 
  AND (
    token = 'Jb60flMN4sNhvfkCFeU5qAGGmGLUFf3YZHyEzxzTDEU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029